Tabela Personnel

Definicja tabeli Personnel

Name

Personnel

Code

Personnel

Comment

 


Lista kolumn tabeli Personnel

Name

Code

PersonnelID

PersonnelID

PersonnelTypeID

PersonnelTypeID

NPWZ

NPWZ

Pesel

Pesel

FullName

FullName

ShortName

ShortName

Code

Code

Active

Active


Kolumna PersonnelID tabeli Personnel

Definicja kolumny PersonnelID tabeli Personnel

Name

PersonnelID

Code

PersonnelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelTypeID tabeli Personnel

Definicja kolumny PersonnelTypeID tabeli Personnel

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NPWZ tabeli Personnel

Definicja kolumny NPWZ tabeli Personnel

Name

NPWZ

Code

NPWZ

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Pesel tabeli Personnel

Definicja kolumny Pesel tabeli Personnel

Name

Pesel

Code

Pesel

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna FullName tabeli Personnel

Definicja kolumny FullName tabeli Personnel

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli Personnel

Definicja kolumny ShortName tabeli Personnel

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Code tabeli Personnel

Definicja kolumny Code tabeli Personnel

Name

Code

Code

Code

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Active tabeli Personnel

Definicja kolumny Active tabeli Personnel

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Lista kluczy tabeli Personnel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Personnel

Definicja klucza Identifier_1 tabeli Personnel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment